SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407714 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407714 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422508,32601,193419,710064,875993,676181,61357,152339,678963,791547,1043289,486244,278491,453461,649047,633723,527097,321923,849124,338926,896141,658470,526625,191397,380820,721312,888338,973812,199273,886840,705066,474589,205704,904548,942396,507256,21321,118216,35912,46810,216738,413276,969861,180126,912259,757413,146469,807684,371858,253976,757064,94074,471517,705302,594708,950266,662948,177812,492300,936098) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]