SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433343 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433343 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101900,278625,312133,192833,889710,924295,878597,635560,76661,662718,109989,538880,74887,608847,176609,944970,142381,1031970,693089,242395,691725,870348,173419,213473,563394,195684,388965,161752,207693,793482,749512,413918,902676,587094,714723,501500,48897,345072,139474,40073,970684,906016,380625,298511,3550,889134,485700,969823,693228,698465,488444,331562,418266,737264,616854,520206,733939,268895,952266,642217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]