SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670160 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670160 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415878,145169,213580,93340,302488,240277,961634,258423,621268,546705,160678,682226,725737,394579,282581,180002,10143,689974,188518,1010249,354501,662696,441040,48978,517533,704412,224162,1035739,1033301,469734,875467,1015150,887009,548884,903683,494324,666494,980663,371134,607424,184840,14990,563516,545127,362514,254167,678588,88258,315503,754079,831270,691658,163314,533046,679737,942401,508112,821237,430415,907777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]