SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403842 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403842 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336765,12795,44912,920911,709785,818079,821143,351745,471854,455724,1557,428044,735273,726113,346239,258137,967599,106735,852952,304487,920424,432621,347698,551558,283728,190079,611706,224157,902972,1025965,501612,54273,8184,665817,530852,764296,296678,803442,746739,313110,183718,370898,488350,522116,8321,207819,534873,967211,736304,342885,808671,936805,735671,590094,121691,585740,648141,342772,259676,376845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]