SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405378 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405378 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351687,327238,409144,1015445,570142,617460,229353,497391,600444,977917,110157,80181,770870,209370,6698,306204,58907,692684,588876,861032,760941,890663,814429,538094,410170,608540,342085,627412,6557,820405,781626,679983,349289,376008,448470,406298,539922,390156,136078,43014,996542,948929,745792,992655,850520,44286,872019,213583,156124,444223,201688,313862,83661,112228,734479,874278,461434,633115,777310,241450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]