SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53196 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53196 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429450,36676,373634,880127,252312,328426,178709,1038941,41459,8704,679375,393122,843752,919702,145633,117387,269601,750488,788768,246011,983914,266325,729020,267882,166195,204487,602566,634792,769675,268069,360665,695611,584559,1045448,1032518,642062,571443,382262,58201,439130,694634,454988,981564,531349,509244,239083,407030,790679,149320,145093,208772,716041,883221,188776,519687,877433,1014344,819272,112978,590865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]