SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476812 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476812 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470125,509392,65170,601878,117098,710706,15869,776980,231201,882478,417546,170331,559841,159844,702692,979397,729269,208688,410287,492844,926457,936985,800566,345143,587213,364096,613930,1045564,254493,555279,72066,516561,962633,567277,707053,578948,846428,176757,217523,467606,1047944,207285,578361,989690,504744,26555,246363,20708,814681,552416,151835,1017363,884613,1035179,104949,179224,949449,859401,789764,216478) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002279s ]