SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 991209 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 991209 [ RunTime:0.002624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159730,45063,1036486,662789,365162,29614,32984,41381,845003,849712,177906,621210,892434,701921,156879,391182,178672,756038,441066,748556,965052,755939,676542,14356,39088,121368,877145,892219,343768,56789,597218,27865,301651,3760,896909,291515,873794,54877,719950,751405,605812,388732,99679,905979,763477,299429,907497,902444,828207,750196,70070,785314,470240,685947,853268,962127,764750,610041,597841,430231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 991209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 991209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]