SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403416 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403416 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334331,968753,808885,328198,925208,597075,230239,255506,687842,349028,671929,238594,538337,281193,54727,508938,38275,242327,100,684784,742229,743073,743668,341063,734500,636128,893145,751046,120061,642118,1013938,875418,492643,751555,199856,273019,332668,442450,207902,255404,331160,141829,322205,679444,134386,29225,512284,337253,688235,552665,41597,551144,590753,971013,195491,574445,1037858,817800,60045,863612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]