SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461991 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461991 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035246,239486,138911,82439,238142,335598,917243,945529,381318,773924,433780,663899,627233,484833,201497,679007,638543,1042301,248572,536312,418004,4568,278596,105515,366371,707863,957385,201323,278368,676766,637112,566959,60668,225016,805335,171409,183936,534124,880716,16858,1014393,956392,377285,114542,894039,302878,984007,644671,578818,883028,161791,267712,1018101,138156,346918,835108,404539,398063,69797,345721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]