SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704800 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704800 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164025,89996,1014856,951177,120684,1032074,522138,831969,135009,235014,26240,826192,143554,629388,571461,806794,613314,796058,126752,874968,714216,627391,741786,477662,302171,776316,727090,206574,588684,564781,729838,532592,275354,288035,807155,42525,455297,9284,111835,934124,870698,17021,833546,634988,291993,825392,955489,334654,73781,194217,941800,701710,822888,661947,987712,815140,927765,406912,467145,1045058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]