SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 326770 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 326770 [ RunTime:0.002894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740543,1028022,145476,666990,847291,793838,964623,663068,361298,436795,997682,961629,555633,48796,89096,346134,923046,622378,356091,767691,1014251,741585,304893,168193,564316,405614,174015,612919,678248,874297,853636,519166,621505,159430,751801,955571,605982,535486,929457,975676,700342,140464,369118,475701,340570,342012,370255,83047,174791,918830,836708,145532,170764,159729,926119,848711,515991,424579,191606,878347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 326770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 326770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]