SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267513 LIMIT 1 [ RunTime:0.001202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267513 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282050,217528,56324,970017,1038422,566348,58869,134184,504736,130301,218405,932564,1007740,524776,473333,954194,838745,1015045,551085,850929,2232,307796,122879,197681,334290,459357,426578,115917,1009192,973758,284714,803521,705744,996010,275464,400910,561398,632901,334042,670254,768715,544783,704239,40911,734544,250552,934604,404299,106134,562509,462781,309022,509260,41612,747140,786381,1027334,128617,102310,927863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]