SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480545 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480545 [ RunTime:0.001904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925290,874783,621402,342096,470817,263244,608824,848489,123046,620850,322815,457240,149819,903102,615224,399962,132243,1000512,1045170,84298,852894,825045,1032678,274210,961922,615933,13284,802554,348121,333152,22300,575815,398547,998377,391449,80123,184612,416144,714016,222000,535175,948146,376454,978273,52200,691626,646180,952109,545659,421422,803889,849111,33258,766369,704090,317055,909698,957065,105880,945275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]