SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 749796 LIMIT 1 [ RunTime:0.001174s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 749796 [ RunTime:0.003229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550929,149506,519855,710642,1020023,276671,703634,413115,118609,548963,293204,336619,378577,936806,100817,264637,898461,472263,236252,259353,101375,721533,383021,861967,205474,529191,607407,353942,514484,557951,887869,401064,115683,127965,503743,383752,324820,856598,325810,113220,445703,93825,843461,897283,141807,874183,222168,900410,39644,1004533,1042054,599164,411276,221349,361032,444908,284150,857092,958269,497929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 749796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 749796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001906s ]