SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 650114 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 650114 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603418,198276,646451,532896,1941,546075,370067,587613,604511,23520,612537,111229,1029693,919710,189395,133141,187457,247495,349193,1011095,203984,706455,654045,827095,979498,353491,783547,431164,89539,498261,774029,205422,612691,358988,922418,786773,450132,56248,875618,87189,624671,369348,165593,578146,277274,770434,294966,788107,374666,128244,858950,362609,392164,1047342,625645,449879,393726,200144,219221,267174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 650114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 650114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]