SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555954 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555954 [ RunTime:0.001908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520121,823150,383556,319492,953002,952101,985955,880421,20463,862359,161078,408133,126455,739454,1015386,752788,764769,842883,22852,237806,798684,670300,249442,98025,520969,715571,955352,23347,19355,190676,449150,923641,622926,318052,880095,430882,684356,223255,360077,472788,629703,157492,97314,759610,800155,13667,805006,1022749,684445,566710,590802,768028,132521,296743,445750,284690,759812,716246,188441,101270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]