SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005517s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264505 LIMIT 1 [ RunTime:0.000505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264505 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710510,808100,956102,529796,932857,277164,289874,231686,818566,529637,798339,798105,69917,196199,296060,52378,18539,551809,957893,1020035,272848,735668,195654,118235,628175,101804,269854,567455,595103,206375,437735,896200,922464,493833,956955,265793,291886,128929,962147,583647,155445,638343,255303,608658,537450,290051,858014,479272,868793,398493,421207,153339,943280,394587,875125,330720,517101,170200,231582,577735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]