SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503185 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503185 [ RunTime:0.003103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602182,1026500,941760,491314,805510,264892,444963,23062,214674,34573,895147,987545,266346,746022,321602,307678,599739,823902,447946,931115,649818,769290,42727,648101,617144,154233,182701,183163,902201,648045,383410,112246,199662,291957,784800,922716,109181,21997,623879,545931,122317,374376,343705,974987,732662,737937,84009,218783,1040646,938612,510439,437566,175747,265400,737303,348917,444009,10560,685542,771904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]