SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310918 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310918 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234286,837895,971755,474687,42544,578053,174490,664849,59771,611504,515260,165684,553108,1041490,968178,722455,316652,134368,891286,367551,249028,446380,586626,490638,778830,287684,342812,544954,778313,777560,965409,935738,908376,287299,1025793,391118,303818,566574,651149,433854,942492,435245,955865,7601,36997,277165,419367,406278,64187,452203,977547,317678,476778,650998,752391,771612,753874,513182,914238,957208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]