SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040543 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040543 [ RunTime:0.002623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599851,680543,299029,181065,785306,132055,97516,698191,159908,248660,554231,571442,915472,570543,915936,125798,586259,638887,585059,96649,358722,304134,270543,561943,884971,326975,891034,821320,8778,81388,322522,200483,514149,92203,950305,433559,3249,922865,570223,534363,99557,255742,406163,977979,448846,284638,59898,487366,404456,967731,458356,265909,673682,110588,851815,712480,333202,72577,124286,876092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]