SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438818 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438818 [ RunTime:0.002392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960351,949680,347403,259269,725463,607268,586531,615445,724608,621760,613461,189318,445890,898072,539020,125885,88131,279590,719709,425090,143506,429511,255735,835700,826503,721082,39698,368392,404658,589885,561561,170283,629071,174333,499735,506840,107810,437323,63054,167303,878005,766258,817823,254040,325843,807320,39541,134363,910091,87976,709496,461728,830291,396654,251808,993854,366212,238808,137531,349560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000813s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]