SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040029 LIMIT 1 [ RunTime:0.001150s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040029 [ RunTime:0.004498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (959882,947057,112850,959680,458626,486446,751945,853838,616203,336923,323717,121198,894526,167527,586298,801597,773285,210613,172499,368198,5736,604156,554568,418344,570087,565227,791570,892758,450048,206329,77949,879704,366548,120623,340082,554810,643881,684302,496440,663832,134372,890914,982054,532244,620089,188522,383837,621579,105369,854862,402508,39638,400884,652663,513656,39361,1012514,490240,240406,5261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]