SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405616 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405616 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163812,144196,517684,995850,590842,401654,720147,382169,860005,545746,41136,390899,632565,1017085,371114,956719,317178,515729,901035,376372,821531,455917,595944,279888,78015,928033,734722,656018,562740,580155,281283,476281,17370,427054,259663,503711,210425,244599,909303,940925,587174,478279,66912,983786,958770,137701,835139,745069,829934,869565,676888,885126,182711,577214,28188,836625,541451,790803,385565,662649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001902s ]