SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039482 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039482 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489505,700401,406465,887382,211190,594209,289131,409160,1048839,41940,602325,823975,205442,332800,1045402,1011841,133592,712736,669266,264396,85963,610143,211387,743687,719543,392562,495535,836164,821846,977211,778039,483436,227228,458499,375298,998331,954640,589044,1041709,716457,407174,510020,724794,350975,61976,794066,1027510,969158,991682,667141,560523,140197,66560,161915,271574,518289,374547,697434,250774,698765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]