SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040063 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040063 [ RunTime:0.001598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434543,689967,240009,291829,998916,160926,930942,518436,228652,859999,929596,1009548,692878,441557,667000,941386,1021472,669933,793081,830013,194095,240440,111634,886294,543494,504887,941841,277571,227464,362021,29878,1044441,155914,773975,708819,962401,161272,639871,253480,858890,891171,795716,837493,42959,170524,16234,68011,1021040,224979,495437,636025,534293,168472,320493,19890,287089,103037,1015342,605590,346130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001952s ]