SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50202 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50202 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366532,75513,71365,84865,720552,176052,684949,47183,219028,252890,708154,206930,771487,226233,129507,613609,741136,105805,861781,242118,79276,533791,36048,895663,558384,248466,530885,503681,628,323720,885216,803721,131870,549491,944349,43059,733150,791686,899135,547466,370160,715403,825361,843428,130731,504072,884,1003088,821640,1041285,757068,114168,985854,532562,770202,8844,419102,575805,880943,762925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]