SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10469 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10469 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620543,90105,42302,467586,1042280,454744,363167,217005,435663,219346,1006218,439528,661434,927716,173191,818470,878183,952522,718914,567694,369837,531040,502291,857988,389037,703134,614369,221361,978109,287782,46406,905903,940592,640256,698012,282452,275451,188459,309040,739781,865830,597069,479071,930333,528475,323584,550314,396754,839024,191992,561181,881736,16891,401000,958023,844103,556201,347553,323580,920420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]