SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107202 LIMIT 1 [ RunTime:0.000716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107202 [ RunTime:0.004687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490680,730601,88676,488952,118448,227694,1021304,115765,6297,796547,188012,68578,406580,329739,126278,520304,443816,369140,62332,506751,24191,373215,185225,890427,237464,401912,53794,436923,348677,634811,150295,502645,180275,874281,150084,354290,554471,338578,907512,116423,385829,151286,663851,655024,30086,160204,910976,615753,813250,324958,929614,299933,708268,79429,354761,202194,541216,514059,1015979,952714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]