SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109081 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109081 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275183,129297,296788,376907,221414,347399,238724,416797,515178,1046471,1019114,442467,1035009,242448,639534,939569,679419,440815,844153,201842,1012454,1010137,446911,423633,12432,874659,443801,714785,745822,219512,1029731,860867,425879,796938,182593,478198,382943,289300,913268,322948,928300,1046167,527164,477239,593327,198889,685666,756232,718576,202536,105641,51123,589054,133838,793335,696879,695956,771636,120131,547513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]