SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436018 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436018 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539723,578196,940787,91473,650948,924232,638502,900931,729057,748055,572492,524958,431158,68542,949156,715563,25300,422421,966777,623414,758368,577606,755236,959243,827511,859511,1042462,641679,878370,925612,281192,1023483,944649,544873,162281,748015,1037384,312308,592791,419500,902941,544075,351791,264053,245178,254581,117634,353133,333262,472457,538008,738572,797416,258984,406664,562623,712670,137394,222578,990641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000907s ]