SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 138913 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 138913 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269583,601347,753577,1045971,992021,632213,867275,10091,187079,637496,875341,690794,744271,948841,908808,803046,21055,319991,916921,28456,450158,479397,920433,134812,502613,965148,964522,864994,210039,811540,382069,840286,297317,1009956,139372,917224,376044,986618,434413,205229,256732,1020189,768719,720984,515659,647488,613716,935550,147441,905470,342850,551251,921584,35369,434317,635085,547177,431059,984557,1033852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 138913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 138913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000837s ]