SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596712 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596712 [ RunTime:0.002494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482906,619867,750220,485084,24342,426508,57478,138780,896700,878807,58392,717645,32599,763312,403326,891301,596498,858487,1031901,166025,1019262,690573,400671,468294,374237,435695,722144,431668,220142,770902,900554,882303,786847,1014247,263639,721161,224384,319349,898302,1001488,1008522,207638,825086,658343,99519,471878,930542,17185,136299,361937,969832,5728,469820,956433,170564,562541,77324,1046845,576665,544150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]