SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403474 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403474 [ RunTime:0.003721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212662,388174,772261,245724,1017039,55094,505800,616829,70822,16987,789664,140577,463979,360795,59354,1039755,125534,986200,623613,80152,649987,341952,345171,250153,166500,149605,926546,299650,524133,962510,489496,708336,853119,455898,119390,133777,999127,320884,300734,306997,625894,970272,269106,771640,981013,220625,678274,75599,368125,714500,670942,198167,420692,739965,171463,47357,612531,754662,904386,114776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]