SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010101 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010101 [ RunTime:0.001815s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492970,145442,116254,440072,648530,896368,116902,726303,411249,478947,462920,1026840,182422,356864,1012554,552699,53228,708084,585586,118751,809792,925586,1040327,191467,884186,427918,697509,976765,76852,1005660,903073,731636,917097,254338,224075,20094,728767,567285,927122,505995,1018989,262025,47453,1045387,924059,1042701,212432,837863,32583,170185,932199,735245,202983,720008,1025701,659948,979241,630378,836575,620528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]