SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583174 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583174 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802405,427615,1027432,290213,310502,142049,208450,452699,396830,172637,512810,1660,735811,589332,222412,447039,414083,102991,357024,380219,151242,700679,527308,983212,316266,247152,271587,240193,460791,301952,171707,36174,807967,683254,610634,68362,1040920,811841,414773,643658,694737,917108,712158,513494,737618,383269,514576,583660,791666,282663,1034494,448203,55365,300151,294132,267310,523029,309339,90308,327558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]