SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204542 LIMIT 1 [ RunTime:0.000504s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204542 [ RunTime:0.001681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642385,891746,853908,760115,780518,970162,309102,225718,483401,1020059,252427,144507,114852,452602,351818,339364,824005,626521,586581,974292,768655,449856,117216,895918,791162,415341,740061,741555,966435,467824,780374,727850,657216,899028,413142,136257,318879,1045153,448282,1008055,219940,275879,7467,212903,970838,934736,501743,111369,76073,230123,269690,84997,791517,531841,662688,820218,923874,699084,464372,684117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]