SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532026 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532026 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756412,51129,625283,65694,335602,739642,498929,449795,936286,275336,21617,295624,514166,967274,834642,1037223,504735,460439,847837,642513,523669,117628,597524,963462,363324,273809,320039,961524,61291,790710,82447,284419,1044610,141399,844390,522660,565492,1028533,427291,564765,917453,725799,177472,146664,813995,453750,660783,888214,243254,457341,656139,383509,444775,1032786,200946,133167,420569,428343,479361,696971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]