SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40101 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40101 [ RunTime:0.002348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612424,17602,92479,888449,802086,473803,662058,759456,147291,888013,169613,375559,952308,226421,166650,360361,810205,529670,712218,487068,901163,910421,128409,877106,333031,319444,714464,36300,425268,803904,555541,15852,184148,355252,370253,425078,275031,523263,426057,875149,293865,876612,597222,812981,862423,458181,323807,853082,909073,753823,777982,446396,130177,351986,903520,679747,695900,929204,386540,654379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]