SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509823 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509823 [ RunTime:0.002386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013713,909991,441201,116850,481051,204617,516499,344804,701481,688614,870773,586175,248904,988558,986949,960659,473455,6702,615589,480257,417716,637088,331963,709317,918811,816739,587934,499683,231365,497247,497909,270382,623809,729766,231066,773943,326211,258711,26795,888433,748650,740820,633497,475321,996678,756525,675152,333089,648082,682505,365139,340134,1037282,183590,254277,280598,685017,675648,928716,53233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]