SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645809 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645809 [ RunTime:0.001990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (889613,715166,445109,1015491,1020835,907955,474917,389710,668086,128537,316421,684479,698977,589546,444900,493505,739818,9874,205126,1017858,606159,40287,757379,986344,216031,513753,36378,150497,46080,708076,307108,174298,815772,617394,434233,616319,672790,744126,892441,2104,93556,356532,936067,356099,137309,299296,717869,645705,816013,887547,651395,66552,379652,181831,632402,487876,399884,187021,387931,858759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]