SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414162 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414162 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020485,196612,60391,267879,111686,8714,420232,80945,963144,1003128,841210,21552,830250,813007,961282,372249,286241,70863,765359,943449,306553,591478,685124,973054,781263,32202,640792,439877,270032,748867,925898,779337,913954,674500,401485,932144,485582,996620,786449,378851,20286,778755,186098,964418,165204,290787,86567,617045,534840,770551,853976,135748,338102,891074,357382,336231,38848,645322,899220,617650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414162 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414162 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000680s ]