SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013400 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013400 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845138,72558,32736,951643,638352,327934,86305,744955,508607,839794,65261,271214,1017338,855244,30696,677675,23945,971238,597302,731376,866478,594687,218732,21045,305889,185869,974695,912964,363817,908295,765863,47801,1024103,516612,718168,899147,245565,19121,917968,806297,931239,907159,418531,879407,133052,754454,724826,167191,370688,895123,474069,274141,191065,917426,580099,965095,402913,817042,1001623,331537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]