SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039193 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039193 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200528,840340,194229,954206,20245,615591,579143,318457,156342,500227,394036,507158,771588,417878,1043091,576619,683861,556576,867298,978370,977502,729550,497827,655189,845839,433337,71080,427894,687472,588248,1014698,239643,200290,808282,940112,805476,295061,316343,583162,873676,182702,818704,859183,778928,489091,354605,103515,257544,240922,543688,301959,98379,564770,187979,680145,791855,171321,862874,57455,315550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]