SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029028 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029028 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790262,782023,730345,345805,584879,388530,164313,854452,417870,452326,854980,682467,388941,749365,614762,867907,926173,554158,44142,503523,40088,256386,253237,221232,853579,476056,1042892,286085,973603,262023,906414,394321,716541,189206,246910,405560,996647,119992,874900,84388,867373,408316,276537,1021289,221009,808495,221013,157148,672666,519621,393330,558302,85623,251111,830121,148212,761250,899667,823642,672481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]