SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399180 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399180 [ RunTime:0.002211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (381319,245052,987580,445107,1048848,788711,468646,422026,553109,528216,521462,788324,201281,813452,105254,837893,968460,360041,911673,291689,348068,1042188,56006,344770,293745,137429,460590,522023,1009270,555379,350000,495646,393744,699825,476410,170891,860819,469014,1024226,538674,455419,797503,984386,112212,163990,739507,604998,538430,814592,516423,529181,1041827,242657,616066,736462,972690,694151,702758,856958,270410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002101s ]