SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 296582 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 296582 [ RunTime:0.002112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188185,120471,498124,411508,984160,270230,43403,1000847,698180,108693,837170,382965,470768,95710,613254,730023,421268,332360,18415,949581,537894,56828,253890,876698,249830,452046,423233,430918,478996,1014509,313180,648387,456393,961366,189784,132737,404612,72124,744840,603510,66575,397146,117269,803776,612777,900474,368383,411884,737606,427236,923945,155565,689556,562452,100322,529959,908609,212190,299509,1037000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 296582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 296582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]