SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447210 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447210 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (633142,426889,292305,711567,140382,744579,333999,302697,670159,727597,440132,641427,1042171,1004907,469913,140067,261514,224487,793572,451132,1041156,596894,401116,30625,240719,640711,481588,814583,912159,213000,291385,894261,910971,847903,339342,103184,436659,501599,335528,706636,514299,563071,49979,282559,140559,879178,175130,711530,722498,628675,602292,988674,904567,713056,125309,931240,714001,946378,314533,862829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]