SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559800 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559800 [ RunTime:0.004694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022862,323507,544234,156427,971562,170558,1040493,973672,354278,271842,435803,427731,791581,747526,104641,1018202,721104,367831,339154,74947,1024866,847852,379868,165876,74047,967109,332300,379818,860304,698286,467306,242007,589469,448756,974978,871001,946347,206532,749638,334036,994842,227122,928028,926721,841342,709075,727123,194951,774029,451229,233352,949349,133298,114272,362824,811749,380141,784086,272687,623518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]