SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391936 LIMIT 1 [ RunTime:0.001201s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391936 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (210694,31103,106701,1034470,121190,570464,1022773,180090,782021,368272,102931,406282,55082,746361,552288,270543,496221,775056,832869,81257,343891,991873,788452,730933,613798,130241,990423,79315,683435,549624,647465,605660,59020,661232,869067,504867,1041291,38788,762574,602751,493926,982397,697133,945840,1023831,126751,350929,478520,879451,290846,631296,121988,601780,333704,312000,407473,898270,411260,1003942,103907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]