SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409678 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409678 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565671,233154,399821,749133,758506,362243,1039578,357562,815098,7990,817244,643958,320805,469409,642388,111249,911347,248887,940440,98866,482389,159654,615538,69451,549949,544740,264581,482057,61074,406709,319406,653753,324815,1034448,675616,45145,636109,393835,422446,716237,322716,746437,466505,433042,290368,13146,160902,1027373,21941,723733,114946,50878,519315,1042728,612558,129981,1030300,403739,29426,837338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]