SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020101 LIMIT 1 [ RunTime:0.001962s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020101 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498795,1025387,1020817,234939,677831,311857,874716,948463,259896,436768,239618,434731,480182,653390,653235,838738,851224,440967,167658,880780,891860,350302,326310,84269,649076,342751,362719,58876,825791,704267,160227,539264,842472,549148,480998,253956,960460,39684,783230,995946,207087,11483,908349,122522,8894,592114,740449,19710,690159,215320,518083,368767,115528,47777,353078,276359,521370,977320,277108,740403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]