SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533716 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533716 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72827,428338,170174,873243,318100,138305,452900,670302,633922,796730,917897,632255,823212,454017,680280,544031,746024,370078,1024857,651650,762648,571750,553802,399009,493319,178803,994642,484190,910772,281290,954957,383641,545968,613444,959413,275599,1008327,653875,612367,8126,458791,757286,648999,62834,295656,289838,791704,166609,365160,521502,769456,178023,1014295,497434,581537,1043937,430063,351958,84766,586078) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]