SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491269 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491269 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149540,386240,490385,692805,1011218,614780,167497,628063,338746,245075,484916,875751,1043564,749603,178945,75464,887372,356027,242328,422183,149995,912818,166259,413783,987131,496286,422203,628487,171042,358058,189120,839009,434140,11540,93521,73344,554458,528993,222206,112803,629435,756590,610462,89909,654840,374554,102849,725398,181340,133524,132623,271054,153029,585881,400981,219287,510951,361717,873755,945899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002419s ]