SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463845 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463845 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931322,38196,369042,555667,376335,875993,688940,2622,702178,221413,732254,577738,218389,89636,1003040,717341,655739,592654,925920,441624,127674,997655,421113,913664,351308,295860,783638,1023495,102206,486123,36028,404351,516706,615490,154027,84924,488953,142357,163057,1028900,559806,719044,142691,287138,1036397,668691,461928,591880,145831,279149,1030033,972406,448769,821917,630974,801642,307659,453425,877649,815654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]