SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581800 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581800 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119810,297737,211986,255966,921760,819626,71151,752451,119469,374136,606314,575362,216804,673098,118732,221497,622703,553858,370747,456498,369737,639325,28824,1027705,842031,769516,50364,316101,861488,293611,711873,839502,804722,608537,321509,1001484,483279,1007033,420242,676268,362430,829636,90797,391346,294938,438495,638037,444783,206391,908943,159515,127375,294458,462568,644513,677415,460562,97310,1034436,23640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]