SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281428 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281428 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603783,717686,994797,270816,1007701,189338,260196,908735,937231,639838,617818,827405,647642,229550,424014,420204,267926,563927,1034130,33061,539129,519936,631650,50536,656590,181552,540748,506491,1026120,852137,160114,982111,1000278,799559,16668,973720,57286,266748,405262,564206,293618,677083,535428,934916,857830,846029,382685,947884,300325,853706,531664,365711,351652,952486,77049,476921,756411,962392,327150,554593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]