SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002361s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000418 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000418 [ RunTime:0.003660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393584,721924,339507,627145,147324,1040147,704411,431213,74863,516388,431988,37980,405088,562913,178062,300290,145474,543179,463637,426425,551038,762746,750133,140805,887927,109864,416808,855924,59095,639901,468062,1031852,593694,479619,687593,496209,722313,660594,136097,376622,953373,58172,311049,444271,1029147,659762,916545,60181,951552,369061,311547,891598,1044572,997444,799663,918661,937631,215059,160464,604373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001803s ]