SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328041 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328041 [ RunTime:0.001456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155743,113603,611479,901896,461376,398264,217762,116716,387683,953513,206834,893769,341685,1038945,754491,918203,95482,801591,50357,305645,994911,766353,598923,849810,906443,791415,838260,721769,335337,24416,684533,511768,180035,873483,718216,160689,151013,94842,970140,316079,608467,314812,741319,797440,858540,261986,316134,479070,195109,810138,454219,431428,5666,611630,539543,455592,241807,476203,290911,617373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]