SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324083 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324083 [ RunTime:0.004101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888071,32948,647885,302402,983501,219050,850027,659556,58031,984471,228233,146611,239275,402935,134523,125935,721013,689878,300011,259345,976675,318639,145200,304304,914839,453042,221115,354882,589565,1041579,443851,537950,317939,658168,133432,610363,60725,719479,829157,532489,1031840,351152,654711,453197,1036084,868278,842866,403059,212295,540261,3100,720728,796994,825713,316872,332670,735844,779643,821355,914376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]