SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 821581 LIMIT 1 [ RunTime:0.001869s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 821581 [ RunTime:0.004184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192812,723491,181608,832976,798756,560848,854130,985262,741805,285354,444161,602056,776078,121109,488880,218137,635060,205687,91670,314613,812163,470039,677125,856813,889544,194034,858558,844447,754778,131873,327268,186409,485885,1000481,711607,639970,282202,544240,295921,959914,294437,778692,444719,479529,233866,708465,928262,469080,271367,697139,641068,318527,783561,583701,84870,254970,427629,903804,505343,171085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 821581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 821581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000940s ]