SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396008 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396008 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585118,703490,627441,110514,10628,251962,648660,776063,408742,981910,859809,465389,466788,1033608,394160,252378,106837,685688,350787,186952,311438,507537,360572,755576,1024702,994656,577014,854751,234119,716818,887618,44996,184345,636290,145869,356424,481895,984121,636805,1038548,319590,947741,225628,472957,177689,22269,255102,798975,834797,417326,799837,704797,318792,153210,87414,282765,462767,689622,272279,727977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]