SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413924 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413924 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64997,904864,578097,181639,864686,820964,244678,415010,944060,38836,175524,958868,146684,194823,1008343,802593,906817,487500,254576,105313,446143,523222,877299,290200,256316,739520,978076,437166,402804,524937,938016,1043562,327056,943991,60081,100206,85047,22610,267067,646379,247315,186610,445013,454218,742279,364957,537928,735827,895071,310884,147138,715742,946903,45897,703378,253757,524884,182960,370634,948590) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]