SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047178 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047178 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347572,984778,31974,164482,973008,900690,965028,231198,528098,1047797,235066,907217,809716,4718,36348,905719,198015,434092,764932,615153,660574,943015,265114,435463,1036411,96464,572562,17228,173844,67929,591745,990604,726792,346960,617045,973408,312289,1016460,283673,225318,999210,390015,301836,325031,828580,565307,560947,55114,886519,723506,816519,458910,235572,1016649,6883,414790,572808,498988,136656,658244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001321s ]