SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842891 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842891 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708216,943333,402588,862960,44533,626047,159260,155753,654193,890860,631497,96027,207908,455347,59390,939437,617114,736267,339359,1046872,99487,30897,1044465,282744,652000,441061,838252,997776,374157,295903,318164,1023164,700007,801842,647946,1016558,729060,198753,590687,282789,381897,34130,582468,1023903,613941,845759,103970,72241,739598,60221,706818,112757,1016260,646339,341210,714212,689290,632163,320441,544791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]