SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410988 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410988 [ RunTime:0.002008s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176661,520310,712119,38210,333605,678387,964779,168488,209582,597294,278179,781341,999347,483189,78790,911367,861845,532364,108565,619864,997025,874681,292744,701541,118583,878264,386328,983869,354568,809045,40425,400626,794334,841252,822396,989657,107153,30212,420144,251803,1009753,3139,541149,743378,427847,492283,298087,74525,840294,213837,420220,680772,107206,835991,641156,725271,245059,306711,121761,76470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]