SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291080 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291080 [ RunTime:0.002513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140094,124713,317121,522196,62149,179031,403348,461865,714261,23719,454363,727319,444555,764892,172987,917559,313263,382854,165539,200389,910934,562628,893830,518487,1014432,273661,274512,451891,780703,575230,1012023,311285,776102,195276,300693,731285,782191,411862,1040049,31122,817867,173092,251427,21417,218834,772538,940385,332034,366463,256443,35130,161067,558701,538140,49028,267370,213124,210517,454464,306107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002429s ]