SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029208 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029208 [ RunTime:0.003226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312167,256733,698439,423527,177887,992824,1010801,112929,160621,920526,560242,674327,226747,872095,375591,155182,389169,659608,515624,827808,921356,866209,995807,269284,965649,624965,416563,865752,293538,305170,682575,10363,406112,871508,663927,989627,297685,1013998,859299,938342,25219,467828,627505,84018,69096,133017,949404,1041089,735819,566883,68486,945854,191179,694037,893615,718763,340925,744879,483602,130588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]