SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102522 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102522 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311275,896608,303444,436031,79024,984177,871421,333162,893786,553269,649530,178048,873447,449292,193366,389483,275122,449025,506697,115628,652638,728560,265701,771108,307192,1019705,624686,1032430,1026264,934335,95221,892152,975078,983422,286017,338449,877538,444623,193675,71062,111188,247625,162291,644308,896012,768023,536011,442185,646455,938005,880344,920952,852056,444333,851249,506070,379558,793943,967922,689892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]