SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534740 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534740 [ RunTime:0.005363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257084,224068,452619,634148,829344,824629,827942,643562,641112,349509,945281,821459,637574,736962,411333,296550,859922,670351,174310,809212,219117,406958,283342,1008387,640442,717864,111253,839202,58217,40603,611850,294800,842542,582765,623785,749230,524696,502414,259384,229481,12140,891166,86531,238904,282205,381239,699997,942414,874912,164716,65767,446104,1032765,15252,248338,470726,783532,805175,421810,433490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]