SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42458 LIMIT 1 [ RunTime:0.001103s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42458 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643111,16965,989440,857400,33726,998009,686587,443572,88681,938855,33288,149821,682240,773298,56158,584802,735616,353546,422791,770151,871140,323242,627305,156147,944872,547539,897062,137009,1010316,155081,930892,682874,908310,230178,169244,579112,260751,254451,592764,161313,911749,859534,432500,335161,199806,70559,417069,583308,518551,512083,11718,864352,893384,611681,453614,1041958,628337,191789,111337,847870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001915s ]